Business Intelligence (Bi) Developer

Ropes & Gray Boston , MA 02298

Posted 2 weeks ago

JOB SUMMARY:

The Business Intelligence (BI) Developer will use Microsoft SQL Server and related technologies to develop and support reporting and data management solutions for the firm. This developer complies with the principles, standards, and best practices outlined by the firm's data architecture, change management, and release management governing bodies.

The BI Developer will partner with BI Analysts to define and document the business requirements for reporting solutions that meet the needs of financial analysts and other stakeholders. This developer will maintain technical documentation including the update of our report inventory, data dictionary, and technical specifications library.

The BI Developer works under the direction and supervision of a Senior BI Developer.

ESSENTIAL FUNCTIONS / JOB DUTIES:

  • Under the direction and supervision of a Senior BI Developer, develop and maintain interactive and operational reporting solutions for the enterprise and prepare code for production deployment

  • Under the direction and supervision of a Senior BI Developer, develop and maintain enhancements to the data warehouse, master data services models, data integration layer, and enterprise data services (stored procedures, views, functions) shared across applications and reporting

  • Provide evidence for the quality and accuracy of solutions by executing unit and integration test plans and present results to a Senior BI Developer for sign-off

  • Support intra-day, weekly, monthly and year-end reporting cycles

  • Comply with the firm's data management principles, policies, standards and best practices as defined by the Data Architecture Working Group

  • Adhere to all documentation standards, development lifecycle tasks, and status reporting requirements

MINIMUM REQUIREMENTS:

  • Bachelor's degree in Computer Science, Information Systems, or related field, or the foreign equivalent

  • Must have developed and deployed 18 parameterized SSRS reports to production over a 12 month period

  • Must have developed and deployed 15 code enhancements of reports and/or data integration solutions to production over a 12 month period

  • 5 years of experience with report development and support using Microsoft SQL Server Reporting Services (SSRS) versions 2008 R2 or 2012 including online parameterized reports and scheduled batch subscriptions

  • 5 years of experience with data integration development and support using Microsoft SQL Server Integration Services (SSIS) versions 2008 R2 or 2012 including job scheduling, error trapping, and success / failure notifications

  • 5 years of experience with SQL development and support using Microsoft SQL Server T-SQL versions 2008 R2 or 2012 including stored procedures, database views, functions, and related objects

  • 5 years of experience with Microsoft Visual Studio & BI Development Studio

  • 5 years of experience in the use of Microsoft Visual Source Safe, Team Foundation Services, or similar source code management solutions

  • 3 years of experience troubleshooting existing SQL code to resolve accuracy and performance problems

  • 3 years of experience developing basic report table / database schemas using consistent naming standards and effective use of primary and foreign key constructs

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
BI ETL Developer Talend

Abilis Solutions

Posted 3 days ago

VIEW JOBS 10/16/2019 12:00:00 AM 2020-01-14T00:00 <p><strong>Take the Next Step in Your Business Intelligence Career!</strong></p><p><br></p>This is a great opportunity to join a nimble consulting organization which values high quality workmanship and strives to serve our client with relevant, modern data solutions. We are an innovative, well-establish eco-system of strategic partners: Tableau, Talend, Snowflake, Cloudera, AWS, and Azure.<p>The BI ETL Developer will be responsible for supporting all the data needs of various departments of our clients. The job functions include, but are not limited to implementation of Data Management &amp; ETL solution using Talend suite, performing complex data analysis, data warehouse design, ETL process and routine implementation, performing data migration (ETL) from several data sources, developing necessary SQL for loading, and updating and maintaining data tables. Also, trouble-shooting data file related issues, and quality control.</p><p>We are looking for a self-motivated individual with a high capacity to learn and execute. Ability to trouble-shoot data issues with a quality control focus is important.</p><p><br></p><p><strong>Why should you join Abilis Solutions? Good question! We asked our employees and this is what they said:</strong></p><p><br></p><ul> <li>Great work environment</li> <li>Focus on a work-life balance</li> <li>Strong customer focus</li> <li>Career growth</li> <li>Amazing people – very multicultural</li> <li>Competitive salary and benefits</li> </ul><p><strong>Main responsibilities:</strong></p><p><br></p><ul> <li>Responsible to help define, date model and build data structures that will serve as the basis for business intelligence and analytics to clients and business partners</li> <li>Will be part of the BI Team and will work closely with the BI data management, architecture and reporting team.</li> <li>Participate &amp; lead Business Requirements, Solution Design and Customer workshop</li> <li>Perform data analysis, dimension modeling and data warehouse architecture</li> <li>Leverage your excellent BI/DW skills to identify and define new BI opportunities</li> <li>Develop and maintain data standards, processes and templates as required to support data-intensive applications;</li> <li>Perform data modelling and provide guidance/consultation on schema designs and extensions/updates;</li> <li>Design and Implement Data integration, quality, profile and ETL process</li> <li>Aid efforts to perform Data mapping, data extraction and loading</li> <li>Identify and recommend opportunities to improve data quality throughout various projects</li> <li>Identify the business implications of data-related decisions</li> </ul><p><strong>An ideal candidate will have:</strong></p><p><br></p><ul> <li>Bachelor’s degree in Computer Science or related field or equivalent combination of education and work experience required</li> <li>7+ years' experience in Business Intelligence, with at least 3 to 5 years of experience with ETL tool – preferably with Talend and/or one or more of: Modeling, DataWarehousing, implementation of Enterprise BI solution</li> <li>Strong knowledge and experience of implementing ETL solution, using Talend tool. Talend Certification will be of an asset</li> <li>Expert in relational database concepts and SQL</li> <li>Demonstrated ability to learn new tools and technologies</li> <li>Knowledge of software or applications development life cycle</li> <li>Ability to conceptualize clients' needs and translate into specific implementation strategies</li> <li>Ability to work independently and as part of a team</li> <li>Experience and knowledge in data management, data modelization, datamart, data warehouse, ETL development, OLAP</li> <li>Knowledge of other ETL tool such as SAP Business Objects Data Services (BODS) and Informatica, will be an asset</li> <li>Knowledge of BigData solutions, such as Hadoop, Cloudera will be an asset</li> </ul> Abilis Solutions Boston MA

Business Intelligence (Bi) Developer

Ropes & Gray