SQL ETL Developer

MS SQL Developer: Financial Data Consolidation

Job Summary:
We are seeking a skilled MS SQL Developer to play a pivotal role in our financial consolidation project. This position involves designing, developing, and maintaining robust SQL Server database solutions to extract, transform, and load (ETL) financial data from multiple disparate accounting software databases (ERP systems) into a centralized data warehouse for reporting and analysis. The ideal candidate will possess strong technical skills in SQL development, a solid understanding of accounting principles, and excellent problem-solving abilities to ensure data accuracy and integrity across all financial systems.

Key Responsibilities:

• Data Extraction and Integration: Design and implement ETL processes using tools like Microsoft SSIS to pull financial data (trial balances, intercompany transactions, etc.) from various source accounting systems (e.g., SAP, Oracle Financials, Microsoft Dynamics).
• Data Transformation & Modeling: Map data from different source systems to a centralized chart of accounts and data model, ensuring consistency and standardization for consolidation and reporting.
• Database Development: Write and optimize complex T-SQL queries, stored procedures, functions, and views to support data manipulation, financial analysis, and reporting needs.
• Data Integrity & Validation: Implement automated data validation checks, constraints, and reconciliation processes to ensure the completeness and accuracy of all financial data before and after consolidation.
• Financial Reporting Support: Collaborate with the Finance and Accounting teams to develop and maintain reports, dashboards, and financial models using tools such as SQL Server Reporting Services (SSRS), Power BI, or Tableau.
• Performance Tuning: Monitor and optimize database performance, troubleshoot issues, and ensure efficient data retrieval for timely month-end close processes.
• Documentation and Compliance: Create and maintain technical documentation for databases, ETL processes, and reporting logic, ensuring compliance with internal policies, SOX, and GAAP standards.
• Collaboration: Work closely with business analysts, finance professionals, and other IT teams to gather requirements, define KPIs, and deliver effective data-driven solutions.
  

Required Skills and Qualifications:

• Technical Proficiency: Advanced proficiency in MS SQL Server and T-SQL programming.
• Data Integration Experience: Hands-on experience with ETL processes and tools, specifically Microsoft SSIS, and data warehousing concepts.
• Financial Acumen: Strong understanding of basic accounting principles, financial reporting (P&L, Balance Sheet, Cash Flow), and the financial consolidation process.
• Problem-Solving: Strong analytical and problem-solving skills with a keen eye for detail to identify and resolve data discrepancies.
• Communication: Excellent communication skills to translate technical information to non-technical stakeholders in finance and accounting departments.
• Experience: Proven experience in a SQL Developer, Data Engineer, or similar role, preferably within the financial services industry or an organization with multi-entity reporting requirements.