Design, Develop, and Optimize Data Pipelines: Architect, develop, and operationalize end-to-end data pipelines that support comprehensive measurement collection, transformation, and analysis using Matillion ETL within hybrid cloud environments.
Data Warehousing in Snowflake: Manage and optimize data warehousing operations in Snowflake, including the development and maintenance of tables, canonical views, user-defined functions, stored procedures, and tasks to ensure a robust and scalable data ecosystem.
Collaborative Data Integration and Transformation: Collaborate with cross-functional teams, including Power BI developers, Power Automate architects, and Artificial Intelligence engineers, to ensure the seamless integration and transformation of data from systems of record into authoritative sources of truth (ASoTs).
Data Quality, Security, and Scalability: Partner with stakeholders to implement best practices for data quality assurance, governance, and security, ensuring compliance with organizational standards and scalability to meet future analytic demands.
Troubleshooting and Issue Resolution: Diagnose and resolve complex data-related issues within data pipelines, data flows, and dashboards to ensure operational continuity and reliability in a mission-critical environment.
Formal Governance Adherence: Operate adeptly within a rigorously controlled governance environment, adhering to formalized approval gates, change management processes, and compliance mandates to maintain enterprise-grade data integrity and security.
Emerging Technology Evaluation: Continuously evaluate and incorporate advancements in cloud technologies, data engineering tools, and best practices, with a focus on AWS and Azure ecosystems, to enhance data operations and drive innovation.
Synergy Building Across Technical Teams: Foster effective communication and collaboration across multidisciplinary teams to align objectives, streamline data workflows, and enable actionable insights through shared technical solutions.
Documentation and Observability: Ensure comprehensive documentation, version control, and observability of all data engineering workflows, pipelines, and processes in alignment with DevOps principles.
Develop Interactive Dashboards: Utilize Power BI and SharpCloud to create innovative data visualizations to support engineering operations and strategic initiatives.

Requirements

Typically requires a degree in Computer Science, Data Science, Systems Engineering, or a related STEM discipline and a minimum of five years of prior relevant experience.
Experience in SQL and Python for complex data transformations, orchestration scripting, and automation tasks.
Experience in data analytics, dashboard development, and data visualization tools (e.g., Tableau, Power BI, SharpCloud).
U.S. citizenship is required as only U.S. citizens are authorized to access information under this program/contract.
Master’s degree in Engineering, Data Science, or a related field (preferred).
Demonstrated expertise in designing and developing data pipelines using Matillion ETL or comparable enterprise-grade ETL tools.
Proven experience managing and optimizing data warehousing environments in Snowflake, including advanced knowledge of schemas and dimensional modeling techniques.
Certifications in RTX CORE Professional, SharpCloud, SAFe, AWS, Azure, or Matillion (preferred).
Experience using SAFe Agile framework and JIRA.
Working knowledge of data analytics and reporting tools to enable insights and actionable decision making.
Familiarity with big data technologies (e.g., Matillion, PowerBI, SharpCloud) and cloud platforms (e.g., Xeta, Snowflake).
Experience with Microsoft Power Platform tools, including Power Apps and Power Automate.

Benefits

Health insurance
Dental insurance
Vision insurance
Life insurance
Short-term disability
Long-term disability
401(k) match
Flexible spending accounts
Flexible work schedules
Employee assistance program
Employee Scholar Program
Parental leave
Paid time off
Holidays

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythondata transformationdata warehousingdata pipeline developmentdata visualizationdata analyticsETLdimensional modelingdata quality assurance

Soft Skills

collaborationcommunicationtroubleshootingproblem-solvingdocumentationgovernance adherencestakeholder engagementsynergy buildinginnovationobservability

Certifications

RTX CORE ProfessionalSharpCloudSAFeAWSAzureMatillion