Advanced proficiency in MS SQL Server and T-SQL programming
Hands-on experience with ETL processes and tools, specifically Microsoft SSIS, and data warehousing concepts
Strong understanding of accounting principles, financial reporting (P&L, Balance Sheet, Cash Flow), and the financial consolidation process
Proven experience as a SQL Developer or Data Engineer in finance or multi-entity reporting environments
Requirements:
Design and implement ETL processes using SSIS to extract financial data from multiple source accounting systems (e.g., SAP, Oracle Financials, Microsoft Dynamics) into a centralized data warehouse
Model and map data from disparate systems to a centralized chart of accounts and data model to support consolidation and reporting
Develop and optimize T-SQL queries, stored procedures, functions, and views to enable financial analysis and reporting
Collaborate with Finance and Accounting to develop and maintain reports and dashboards using SSRS, Power BI, or Tableau
Job description
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.
