Sr System Analyst (Strong SQL / Strong Ab Initio)

• 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.

• 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)