Sign upLog in

SQL ETL Developer

EDI Staffing

Independence, OH

Apply
JOB DETAILS
SKILLS
Accounting, Accounting Close, Accounting Consolidation, Accounting Software, Analysis Skills, Balance Sheet, Business Analysis, Cash Flow, Communication Skills, Data Modeling, Data Quality, Data Recovery, Data Warehousing, Database Extract Transform and Load (ETL), Database Optimization, Database Programming, Detail Oriented, Documentation, ERP (Enterprise Resource Planning), Finance, Financial Analysis, Financial Modeling, Financial Reporting, Financial Services, Financial Systems, Generally Accepted Accounting Principles (GAAP), Identify Issues, Maintain Compliance, Microsoft Dynamics, Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Oracle Financials, Performance Analysis, Performance Metrics, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Profit & Loss, Reconciliation, Reporting Dashboards, Requirements Management, SAP Financials, SQL (Structured Query Language), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Sarbanes-Oxley Act (SOX), Stored Procedures, Tableau, Technical Writing, Time Management, Trial Balances, Validation Testing
LOCATION
Independence, OH
POSTED
30+ days ago
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.

About the Company

E

EDI Staffing

At EDI Staffing, we strive to provide the best staffing solutions for each of our business disciplines, in honest, resourceful, and creative techniques. Our mission is to connect talented people with great organizations across all industries, while maintaining our company values: accountability, innovation, integrity, teamwork and work ethic. Our commitment to our values becomes tangible in our daily customer interactions and lifetime customer relationships.

COMPANY SIZE
100 to 499 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1994
WEBSITE
https://www.edistaffing.com/

Resume Resources

Free Resume TemplatesFree Resume Builder