Santa Monica CA_Local Reports Developer(ETL, SSIS exp)

360 IT Professionals; Santa Monica (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

A software development company based in California is seeking a SQL Reports Developer in Santa Monica, CA. The role requires over 3 years of experience in report development and strong SQL programming skills. Candidates should be proficient in ETL tools like SSIS and have solid Microsoft Excel capabilities, including VBA and Macros. The company focuses on delivering high-performance technology services tailored to client needs, ensuring a dynamic work environment and opportunities for professional growth.

Qualifications

• 3+ years' experience in report development.
• 2+ years' experience with ETL tools, SSIS preferred.
• Outstanding SQL programming skills with advanced query writing.

Responsibilities

• Develop dynamic reports using SSRS.
• Troubleshoot performance issues in reports.
• Ensure full life cycle development discipline.

Skills

SQL programming skills

ETL tools (SSIS)

Microsoft Excel

SSRS report development

Verbal and written communication

Tools

Microsoft .NET framework

SQL Server 2008R2/2012/2014

Job description

Santa Monica CA_Local Reports Developer(ETL, SSIS exp)

360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement.

We are looking to fill a position for SQL Reports Developer in Santa Monica CA

• Contract
• 3+ years’ experience working in report development
• 2+ years’ experience working on ETL tools – SSIS preferred.
• At least 2-year experience of development using Microsoft .NET framework preferred
• Outstanding SQL programming skills, with ability to write advanced queries, read data models, and understand dimensional table relationships
• Strong Microsoft Excel skills. Experience with VBA’s and Macros, Pivot tables and Pivot Reporting highly desirable.
• Strong verbal and written communication skills
• Excellent with SQL Server 2008R2/2012/2014, including writing T-SQL, with ability to write stored procedures, CTE’s, user defined functions & SQL queries
• Ability to develop dynamically parameterized, drill down, matrix, and chart SSRS reports
• Excellent analytical and troubleshooting skills and ability to trace report performance issues to root cause.
• Strong experience using SSRS report manager and report viewer
• Strong discipline in full life cycle development
• Good understanding of Project Management Methodology.
• Experience working in Financial, HR and Payroll preferred but not required