Sr System Analyst (Strong SQL / Strong Ab Initio)

Overview

We are seeking a highly skilled Senior System Analyst with strong expertise in SQL and Ab Initio to join our dynamic data engineering team. This role offers an exciting opportunity to lead complex data integration and management projects, leveraging cutting-edge big data systems and cloud technologies. As a key player, you will drive the design, development, and optimization of scalable data pipelines and analytics solutions that empower business decision-making. Your energetic approach and technical mastery will help shape our data landscape, ensuring robust, efficient, and innovative data solutions across the organization.

Duties

• Lead the development and maintenance of high-performance ETL (Extract, Transform, Load) pipelines using Ab Initio, ensuring seamless data flow across multiple platforms including cloud environments such as AWS, Azure Data Lake, and Public Cloud infrastructures.
• Design and implement complex SQL queries and stored procedures within Microsoft SQL Server, Oracle, and cloud databases to support reporting, analytics, and business intelligence initiatives.
• Collaborate with cross-functional teams to gather requirements, translate business needs into technical specifications, and develop scalable data models using dimensional modeling techniques for data warehousing solutions.
• Manage big data systems utilizing Hadoop ecosystem components like Apache Hive, Spark, and Hadoop Distributed File System (HDFS), ensuring efficient processing of large datasets.
• Integrate diverse data sources including linked data, RESTful APIs, and enterprise applications using Informatica, Talend, and custom scripting in Python or Bash (Unix shell).
• Optimize query performance and manage query execution plans to improve system efficiency while maintaining data integrity.
• Support the deployment of analytics tools such as Looker for business intelligence reporting and visualization; assist in model training and analysis to derive actionable insights.
• Participate actively in Agile development cycles to ensure timely delivery of high-quality solutions; contribute to continuous improvement initiatives within the team.

Experience

• Proven experience as a Senior System Analyst or similar role with a focus on SQL databases (Microsoft SQL Server, Oracle) and ETL pipeline development in complex enterprise environments.
• Strong proficiency in Ab Initio for designing scalable data integration workflows; demonstrated ability to troubleshoot and optimize Ab Initio graphs.
• Extensive knowledge of big data technologies including Hadoop ecosystem components (Hive, Spark), cloud-based data lakes (Azure Data Lake), and public cloud platforms such as AWS.
• Hands-on experience with data modeling techniques including dimensional modeling for warehouse design; familiarity with Data Management Integration practices is highly desirable.
• Skilled in software development using Java, Python, VBA or Shell Scripting for automation and custom integrations.
• Familiarity with business intelligence tools like Looker or similar platforms for creating dashboards and reports.
• Strong understanding of cloud databases (Azure SQL Database, Amazon RDS), data warehousing design principles, query management strategies, and ETL pipeline architecture.
• Excellent analysis skills with the ability to interpret complex datasets; experience with model training is a plus.
• Knowledge of Agile methodologies such as Scrum or Kanban; ability to work collaboratively within fast-paced teams focused on innovative solutions.

Join us to be part of a forward-thinking organization that values your expertise in big data systems, cloud technologies, and advanced analytics!

Pay: $55.00 - $60.00 per hour

Experience:

• complex SQL queries : 5 years (Required)
• Ab Initio: 5 years (Required)
• ETL: 5 years (Required)

Work Location: In person