Data Analyst

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Apex Systems, is seeking the following. Apply via Dice today!

Job#: 1369053

Job Description:

Responsibilities:

• Migrate existing Pentaho ETL integrations to Azure cloud platform
• Develop and maintain data pipelines using Azure Data Factory and other relevant Azure technologies
• Optimize ETL processes for performance and scalability, leveraging Azure services such as Azure Data Factory Mapping Data Flows, Azure Data Lake Analytics, or Azure Synapse Pipelines
• Extract data from various sources, transform it into a usable format, and load it into Azure data storage solutions such as Azure SQL Database, or Azure Synapse Analytics
• Collaborate with cross-functional teams to understand data requirements and design scalable and efficient ETL processes using Azure services
• Identify, design and implement ETL solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis
• Analyze business and technical requirements, as well as data warehouse data models, to understand the detailed data management requirements
• Administer, maintain, develop and recommend policies and procedures for ensuring the performance, availability, security and integrity of the companys databases and systems
• Architect solutions to help implement the physical data model for the development and/or production environments
• Perform regular deployments, scheduled maintenance and housekeeping
• Work with business and analysts and solution architects to identify, design and implement custom user interface programs for data management and extraction purposes
• Manage job and activity schedules to promote optimal performance, maximum availability and minimize data latency and data load durations
• Implement data quality checks, data validation, and data cleansing techniques to ensure accuracy and reliability of the data
• Collaborate with data analysts to understand their data needs and provide them with clean, reliable, and well-structured data sets for analysis and modeling
• Ability to Extract, Transform, Load, Manage and Troubleshoot daily transaction files from various processors
• Ability to identify and validate data needs and/or information from external clients and internal staff
• Ability to extract and prepare data for analysis across multiple platforms
• Perform data quality analysis to ensure data integrity and accuracy of production data
• Ability to proactively identify areas for improvement in data performance, quality, and processing

Qualifications:

• Bachelor's degree in Computer Science or related field plus 0-2+ years of relevant work experience; or a Masters degree plus 2+ years of relevant work experience
• In lieu of a degree, qualified candidates would require 4+ years of relevant professional experience
• Proven experience being accountable for the data /analytics architecture solutions for a given business area -how all the components, subsystems, platforms, and integrations fit together to meet the business needs and how the solution fits in with the greater enterprise context
• Strong experience in data extract transform load (ETL) processes using Azure services, such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL Database, or Azure Synapse Analytics
• Proficiency in SQL and scripting languages such as Python or PowerShell for data manipulation and transformation
• Technologies include Azure SQL, Cosmos DB, Azure Synapse, Power BI
• Familiarity with data modeling concepts and best practices
• Solid understanding of data integration patterns and techniques
• Experience with data quality management and data governance principles
• Strong problem-solving skills and ability to work in a fast-paced, collaborative environment
• Excellent communication skills to effectively convey technical concepts to both technical and non-technical stakeholders
• Experience with legacy ETL tools such as Pentaho, Informatica.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico.