Sign upLog in
See more jobs

SQL ETL Developer

CirrusLabs
  • Independence, OH
    11 days ago

    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.

    Numbers & Facts

    LocationIndependence, OH

    Skills

    • Accountingunmatched
    • Accounting Closeunmatched
    • Accounting Consolidationunmatched
    • Accounting Softwareunmatched
    • Analysis Skillsunmatched
    • Balance Sheetunmatched
    • Business Analysisunmatched
    • Cash Flowunmatched
    • Communication Skillsunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Recoveryunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Database Optimizationunmatched
    • Database Programmingunmatched
    • Detail Orientedunmatched
    • Documentationunmatched
    • ERP (Enterprise Resource Planning)unmatched
    • Financeunmatched
    • Financial Analysisunmatched
    • Financial Modelingunmatched
    • Financial Reportingunmatched
    • Financial Servicesunmatched
    • Financial Systemsunmatched
    • Generally Accepted Accounting Principles (GAAP)unmatched
    • Identify Issuesunmatched
    • Maintain Complianceunmatched
    • Microsoft Dynamicsunmatched
    • Microsoft Product Familyunmatched
    • Microsoft SQL Serverunmatched
    • Microsoft Transact-SQL (T-SQL)unmatched
    • Oracle Financialsunmatched
    • Performance Analysisunmatched
    • Performance Metricsunmatched
    • Performance Tuning/Optimizationunmatched
    • Power BIunmatched
    • Problem Solving Skillsunmatched
    • Profit & Lossunmatched
    • Reconciliationunmatched
    • Reporting Dashboardsunmatched
    • Requirements Managementunmatched
    • SAP Financialsunmatched
    • SQL (Structured Query Language)unmatched
    • SQL Server Integration Services (SSIS)unmatched
    • SQL Server Reporting Services (SSRS)unmatched
    • Sarbanes-Oxley Act (SOX)unmatched
    • Stored Proceduresunmatched
    • Tableauunmatched
    • Technical Writingunmatched
    • Time Managementunmatched
    • Trial Balancesunmatched
    • Validation Testingunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder