SMX Services & Consulting, Inc.

Data Analyst Developer

Posted: Oct 16, 2025

Job Description

What the role will do:Conduct analysis of existing data structures along with the data architectPerform data feed low level design to feed the Oracle database schemas and Data Lake in Azure Synapse.Participate in data analysis and data design meetings and clearly articulate ideas, gather detailed business needs and outcomes expected, share best practices, and ensure that the DB design is reviewed in terms of structural integrity.Perform data profiling and data analysis to assist in understanding the data.Work with large data sets to migrate to new data structuresClean, merge, manage, and ensure quality of data sets. Qualifications:Bachelor's Degree Information Technology, Computer Science, or related field. PreferredBachelor's Degree Information Technology, Data Analytics, Business Administration-Information Processing or related discipline. Preferred3-5 years in building pipelines to feed a data warehouse or other data entities using ETL tools or pipelines - Required3-5 years in writing complex SQLs to perform data analysis, data cleansing and segmentation - Required5-6 years in systems and data impact analysis, data base logical and physical design, building ERDs, conducting DB design review sessions with sound knowledge of RDBMS, Data Engineering principles and the tenets of data management – RequiredTechnical Skills: Strong hands-on experience in Oracle PLSQL, Relational DB principles and design, building Azure Pipelines to feed a Data Warehouse or Data Lake, and building ETL scripts using any standard ETL tool (SAP BODS Preferred), and ability to develop scripts to schedule ETL jobs

Job Application Tips

  • Tailor your resume to highlight relevant experience for this position
  • Write a compelling cover letter that addresses the specific requirements
  • Research the company culture and values before applying
  • Prepare examples of your work that demonstrate your skills
  • Follow up on your application after a reasonable time period

Related Jobs