• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 28th Dec 2023

Technical/Functional Skills:

• 5+ years of expert TSQL/Procedural language and SSIS experience 

• Strong SQL experience, specifically SQL Server 2012. 

• Knowledge of data governance standards. 

• Advance TSQL coding a must 

• Hands on Dimensional Modeling 

• Hands on data transformation with SSIS and SQL Agent for automation and scheduling 

• Good understanding of Data warehouse concepts. 

• Azure working knowledge, don't need to be expert 

• Tableau knowledge is good to have

Job Responsibilities

• Defines, develops, and implements automation of reports, processes, and interfaces. 

• Designs and develops models to improve financial analysis and to project financial impact of business changes. 

• Interprets and translates accounting and finance business needs into effective applications and operational requirements to assist IT staff with implementation of finance and accounting system solutions. 

• Works with IT and Finance to perform testing and facilitate implementation of data warehouses. 

• Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data. 

• Understands and compiles accurate data to present reports and assesses data quality. 

• Applies a broad range of techniques and theories from business intelligence, data analysis and visualization, statistics, and predictive analytics to deliver actionable business insights based on large-scale data. 

• Defines, captures, enriches, explores and preps data to support desired metrics monitoring and reports. 

• Troubleshoots and resolves problems related to accounting and finance systems and applications.

Skills: 

·         Extensive knowledge of SQL

·         SQL Server Management Studio experience

·         Extensive knowledge of complex data models

·         Strong data analysis/mining experience

·         Strong data validation skills

·         Strong Experience with ETL tools

·         Driving curiosity and attention to detai

Reporting: 

·         Provides thorough, visible, rigorous and transparent data reports and analysis.

·         Tracks trends and provides recommendations for solutions based on findings.

·         Interprets and communicates analytical insights to audiences with various analytical backgrounds using different but suitable communication methods for different audiences.

·         Develops visually appealing and intuitive dashboards that provide visibility into key performance, risk, and control indicators across agency divisions and departments