SQL BI Developer W/C# + Azure

Aptonet Inc Santa Ana , CA 92707

Posted 2 months ago

SQL BI Developer w/C# + AzureH1B, C2C and OPT will not be considered for this roleMUST HAVE:Very strong C# skills and experience enhancing C# legacy codeT-SQL experienceSSRS ExperienceAzure ExperienceOLAP/OLTPVeracode or equivalent code scanning toolOverview:This consultant will participate in the design, development, coding, testing, debugging, and maintenance of enterprise level applications and database systems for business applications in a multi-level server environment. The developer will work collaboratively with end users and application teams from within the finance database unit. They will work in coordination and support of all managers and users requiring any data and decision support. The candidate must be able to troubleshoot the existing C# code and to develop new codes, stored procedures, views, functions and triggers. Must be able to document the data flow and map the existing databases. In addition, the developer also will create, enhance, or leverage reporting solutions to solve organizational problems through ETL, reports, analysis, or data visualization.Duties:Provide business users with the data required for metrics and analysis.Assists in the maintenance support of legacy programs and systems as determined by the IT manager and/or team leads.A large portion of their time will be spent surrounding enhancing C# legacy code.Perform independent audits and reviews and validate data integrity.Interact with non-technical business users in order to gather requirements for BI solutions.Requirements:Fluent with Microsoft .NET framework, including C# and ASP.NET5-8 years of experience in SQL Server development (MS SQL Server 2005/2008/2012/2014) with a good knowledge of T-SQL.SSRS experience, designing and developing reports.Familiar with ETL concept and SQL Server Data Tools.Good understanding of multi-dimensional data model, OLAP, and OLTP.Experienced with Veracode or equivalent code scanning tools.Excellent documentation skills, preferably familiar with UML.Detail oriented with strong analytical and troubleshooting skills.Effectively communicate and interact with both functional and technical personnel in solving complex business and technical problemsAbility to complete tasks within critical timelines and work well in a fast-paced, high-energy environment.Able to proactively work alone and within a team environment.Work outside normal business hours, as required for completing projects, working on deployments and resolving system outages.Knowledge of Azure Data Factory is a plus.Knowledge of SSAS and CUBE creation is highly preferred.Knowledge of Power BI is a plus.Finance experience is a plus.College grad in computer science and related degree.
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
Java Developer

Edison International

Posted 2 weeks ago

VIEW JOBS 10/10/2020 12:00:00 AM 2021-01-08T00:00 Join the Clean Energy Revolution Interested in the utility industry and its near future Grid Modernization solutions? Become a Java Developer at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll be responsible for developing software to integrate the Grid Management System (GMS) with other applications within SCE and on the cloud. You will provide technical leadership in day-to-day technical activities to design and develop these interface adapters. Post go-live of GMS project and develop any enhancements needed or troubleshoot and fix any reported issues on these interfaces. As a Java Developer, your work will help power our planet, reduce carbon emissions and create cleaner air for everyone. Are you ready to take on the challenge to help us build the future? A day in the life - Get ready to think big, work smart and shine bright! * Working with the business clients to understand their requirements and ongoing strategy to provide technical solutions for meeting their short-term and long-term business goals. * Design and architect solutions that that are resilient and secure and comply with SCE's cyber standards. * Be part of an Agile development team developing integration applications from scratch using the Java Spring Boot framework. * The position will perform complex analysis, consultation, and provide recommendations to address complex technical issues as they relate to the operation and control of an electric utility as well as lead the implementation and deployment of replacement, upgrade, or enhanced versions of the applications and platforms. * Brainstorm architecture, design, and implementation strategies with the team. * Through breadth and depth of advanced technical knowledge, provides application and system subject matter expertise for related systems. * Communicate to peers, IT support teams, IT leadership, and SCE executives regarding short-term and long-term system goals and technology roadmap. * Collaborate with vendors and senior leadership directly as well as engineers, IT specialists, architects, and analysts from various disciplines to achieve desired business outcomes. The Essentials * Seven years of software development experience. * Full stack development experience using Java EE. * Experience working on large scale enterprise grade applications troubleshooting and resolving distributed applications. * Hands-on Microservices development experience using Spring Boot framework, building scalable/secure Restful style APIs. * Experience in an Agile development team with hands-on knowledge of DevOps tools and CI/CD practices. The Preferred * Bachelor's or Master's Degree in Engineering, Science/Technology, or related field. * Strong understanding of Cybersecurity standards and trust zones to implement a defense in depth application security. * Good understanding of infrastructure and networking capabilities to design resilient systems. * Understanding of OpenAPI Standards. * Experience in troubleshooting message transactions spanning multiple applications across different security trust zones. * Understanding of Kubernetes and deployment of application containers to a K8S cluster. * Experience with Containerization of services. * Technical knowledge of Transmission and Distribution networks, SCADA and control systems. * Leadership experience working with cross-functional teams, clients and vendors. * Strong interpersonal, influence, and negotiation skills. You should know * Visit our Candidate Resource page to get meaningful information related to benefits, perks, resources, testing information, and hiring process, and more! About Southern California Edison The people at SCE don't just keep the lights on. Our mission is so much bigger. We're fueling the kind of innovation that's changing an entire industry, and quite possibly the planet. Join us and create a future with cleaner energy, while providing our customers with the safety and reliability they demand. At SCE, you'll have a chance to grow personally and professionally, making a real impact in Southern California and around the world. At SCE, we celebrate our differences. We are a proud Equal Opportunity Employer and will not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected status. We are committed to ensuring that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. #LI-JM1 Edison International Santa Ana CA

SQL BI Developer W/C# + Azure

Aptonet Inc