Sr Data Engineer

Sr Data Engineer

Genesis10 is currently seeking a Sr Data Engineer for a hybrid position with a Major Financial Institution located in Scottsdale, AZ. This is a 12+ month contract opportunity. Summary: This role focuses on designing, developing, and maintaining robust data pipelines and ETL processes. The ideal candidate will have extensive experience with on-prem SQL servers and cloud-based Azure data infrastructure, including Azure Data Factory, Databricks, and Power BI, to transform and visualize data within a financial services environment.

Responsibilities:

• Design, develop, and maintain data pipelines and ETL processes to extract, transform, and load data from various sources into our data warehouse
• Deliver data reporting requirements on On-Prem SQL Servers using SSIS and/or other integration processes
• Code and implement data pipelines in cloud-based data infrastructure in batch and streaming ETL using Azure Data Factory, Spark, Python, and Scala on Databricks
• Optimize data ingestion and transformation processes to ensure efficient and scalable data flows
• Monitor and optimize database performance, including query tuning and index optimization
• Develop and maintain data models, schemas, and data dictionaries for efficient data storage and retrieval
• Perform data analysis, data profiling, and data cleansing to ensure data quality and accuracy
• Conduct data validation, quality checks, and troubleshooting to identify and resolve data-related issues
• Develop Power BI dashboards, reports, and visualizations to effectively communicate data insights
• Create and maintain technical documentation related to database structures, schemas, and reporting solutions
• Stay up to date with industry trends and best practices in data engineering and Power BI

Requirements:

• Bachelor's degree in Computer Science or Information Systems or equivalent work experience
• 10+ years of experience in a related field
• Solid experience with database design practices and data warehousing concepts
• Hands-on experience with On-Prem SQL Servers using SSIS
• Expertise with Azure Data Factory, Spark, Python, and Scala on Databricks
• Experience working with Azure Data Lake Storage and Azure SQL Databases
• Experience working with Databricks Delta Lake, Medallion Architecture, and Unity Catalog
• Experience developing Power BI dashboards, reports, and visualizations
• Experience with build and deploy tools such as Azure DevOps, GitHub, or Jenkins
• Experience working on an Agile Development team using tools like Jira and Confluence
• Strong communication, interpersonal, analytical, and problem-solving skills

Desired skills:

• Experience with API/REST and JSON
• Experience in Banking and Financial Domains
• Industry certification in Azure, GCP, or AWS
• Familiarity with programming languages like Java, JavaScript, or C/C++
• Familiarity with containerization and orchestration technologies (Docker, Kubernetes)
• Experience with shell scripting in Bash, Unix, or Windows shell
• Experience with Power Automate and Power Apps
• Experience with Collibra Data Lineage and Data Quality Modules

Pay range: Up to $78.18 per hour

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years, Genesis10 puts thousands of consultants and employees to work across the United States every year in contract, contract-for-hire, and permanent placement roles. With more than 300 active clients, Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

For contract roles, Genesis10 offers the benefits listed below. If this is a perm-placement opportunity, our recruiter can talk you through the unique benefits offered for that particular client.

Behavioral Health Platform

Medical, Dental, Vision Health Savings Account

Voluntary Hospital Indemnity (Critical Illness & Accident)

Voluntary Term Life Insurance

401K

Sick Pay (for applicable states/municipalities)

Commuter Benefits (Dallas, NYC, SF, and Illinois)

For multiple years running, Genesis10 has been recognized as a Top Staffing Firm in the U.S., as a Best Company for Work-Life Balance, as a Best Company for Career Growth, for Diversity, and for Leadership, amongst others.

To learn more and to view all our available career opportunities, please visit us at our website. Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.