Primary Location:
17 Cowboys Way
Locations:
Frisco, TX US
Additional Locations:
17 Cowboys Way; Auburn Hills Operations Center
Job Type:
Full-time
WorkBest Job Category:
Category C – Days in the office will either be designated days or will vary week to week from 2-5 days
Job Category:
Technology
Required Experience:
7-12 years
Overtime Status:
Exempt
Job ID:
245610
Principal Data Engineer – IICS & Snowflake ETL
- Work closely with business units, application teams, infrastructure areas and vendors to identity, review and evaluate the solution requirements.
- Investigate and propose strategic fits for virtualization, consolidation and rationalization solution opportunities within the infrastructure or business. Propose changes to the technical architecture and design solutions as applicable.
- Evaluate and align strategic fit solutions across infrastructure platforms and solutions specific to system hardware and software technologies.
- Understand, participate, review and influence long term capacity planning and technology investments.
- Provide Client consulting and planning guidance as applicable for moderate to large highly complex projects/programs.
- Provide consultation and works closely with other functional infrastructure areas/departments on multiple initiatives to meet common organizational / business goals and objectives.
- Participate in and provides consulting to project teams on architectural, design development, integration opportunities, planning of highly complex systems and assures it is aligned to our established strategies, guiding principles, rationales and practices.
- Identify and evaluate projects/programs/initiatives and design processes that enhance and rationalize existing and upcoming solutions.
- Map requirements into standard services solution, identity opportunities for integrating to existing or reuse technology and provide cost effective solutions for moderate to large highly complex project/programs/initiatives.
- Review, identify and manage requirements for moderate to complex solutions and do a cost value, feasibility and risk analysis.
- Review, participate, develop and update architectural standards, guiding principles, rationales and strategies.
- Evaluate, review and approve highly complex design solutions for business and Infrastructure project or programs or initiatives.
- Bachelor’s Degree from an accredited university in Computer Science, Engineering or in a Technology related field OR equivalent through a combination of education and/or technology experience OR 12 years of technology experience
- 7 years of experience in identifying technical solutions for complex business problems, identifying the benefits and risks of the solutions and providing recommendations
- 6 years of experience in Technology
- 6 years of experience in Data Engineering, BI Engineering or related field in architecting and developing end-to-end scalable data applications and data pipelines
- 6 years of experience using Informatica with 3 years IICS experience in extracting, transforming/manipulating, and loading data sets using programming (e.g., Python) or querying languages (SQL) and relevant experience in data profiling, data quality, catalog tools
- 6 years of experience working in enterprise data warehouse solutions and platforms, and working knowledge of different databases (e.g., SQL & NoSQL), S3 Datalake, CICD, Jenkins and AWS cloud technologies
- 5 years of experience mentoring another technologist
- 4 years of experience using Snowflake in extracting, transforming/manipulating, and loading data sets using programming SQL or Python
- 4 years of experience working with software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes and testing
- This position is not eligible for sponsorship. Must have indefinite employment authorization.
Licenses/ Certifications:
- Amazon Web Services (AWS) Solutions Architect Associate
- Preferred, Informatica Data Management Cloud Certification – Developer or Administration
17 Cowboys Way8:00am – 5:00pm Monday – Friday