Job Description

Talascend is currently seeking a Cloud Data Engineer for a contract opportunity with our client in Washington, District Of Columbia.
Overview
The role involves designing and implementing full lifecycle data pipeline services for Azure cloud-based data lake, SQL, and NoSQL data stores. The ideal candidate will translate business requirements into data engineering solutions to support an enterprise-scale Microsoft Azure-based data analytics and reporting platform.
Responsibilities

• Maintain and operate legacy ETL processes utilizing Microsoft SSIS, Powershell, SQL procedures, SSAS, .NET code, and other technologies.
• Implement full lifecycle Azure cloud native data pipeline development and operation.
• Work closely with client personnel and team members to understand data requirements and develop appropriate data solutions.
• Support the design and implementation of data models and data pipelines for relational, dimensional, data lakehouse (medallion architecture), data warehouse, data mart, SQL and NoSQL data stores.
• Utilize Microsoft Azure services including Azure Data Factory, Synapse Pipelines, Apache Spark Notebooks, Python, SQL, stored procedures to develop high performing data pipelines.
• Redevelop existing SSIS extract, transform, load scripts to Azure Data Factory and Synapse Pipelines.
• Identify, create, prepare data required for advanced analytics, visualization, reporting, and AI/ML.
• Implement data migration, data integrity, data quality, metadata management, and data security functions to optimize data pipelines.
• Monitor and troubleshoot data related issues to maintain high availability and performance.
• Implement governance, build, deployment and monitoring to automate platform operation.
• Actively support Agile DevOps process, including Program Increment planning.
• Actively engage in continuous learning to increase relevant skills.
• Maintain strict versioning and configuration control to ensure integrity of data.

Qualifications

• Bachelor's degree and 8+ years of prior relevant experience
• Masters with 6+ years of experience

Requirements

• 4+ years of experience developing and maintaining ETL processes using Microsoft SSIS, SQL, SQL Agent, and scripting languages including Powershell.
• 4+ years of experience with more than one of the following scripting languages: SQL, T-SQL, Python, PySpark.
• Experience working with Microsoft database and business intelligence tools, including SQL Server, including stored procedures, SSIS, SSRS, SSAS (cubes), scripting languages including PowerShell.
• U.S. Citizenship Required
• Security Clearance Required: Public Trust

Shift
Remote (Quarterly travel to DC)
We thank all applicants for their interest. However, only those qualified individuals who closely meet the qualifications of the position will be contacted. The details of the position are only a summary, other duties may be assigned as necessary.
Background Check and Drug Screen may be required.
Pay range is not a guarantee of compensation or salary, as final offer amount may vary based on factors including but not limited to experience and geographic location. Talascend also offers a variety of benefits including: health and disability insurance, 401(k), EAP, paid time off, and company-paid holidays. The specific programs and options available to an employee may vary depending on date of hire, plan requirements, schedule type, and client work site mandates.
Talascend is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

Skills Required